Certified Tableau Data Analyst v1.0
Question 1
Which function should a Data Analyst use to aggregate total regional sales for a dataset regardless of what is in the view?
- A. FIXED
- B. INCLUDE
- C. EXCLUDE
- D. SUM
Answer : A
Question 2
What does a Web Data Connector allow a Data Analyst to do?
- A. Scrape data from an HTML table.
- B. Publish data to the company website.
- C. Capture website traffic.
- D. Connect to an API.
Answer : D
Question 3
A Data Analyst has the following two tables.
Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?
- A. Outer join
- B. Left join
- C. Inner join
- D. Right join
Answer : B
Question 4
A Data Analyst is working with the following dataset.
The analyst is trying to build a box plot showing the distribution of discounts offered to different vendors (something that will look like the following box plot).
Which action does the analyst need to take next to achieve the desired box plot?
- A. Change AVG(Discount) field aggregation to Count Distinct.
- B. Add Invoice Number to the Marks card detail shelf.
- C. Allow whiskers to extend to the maximum extent of the data.
- D. Covert AVG(Discount) field to Discrete.
Answer : B
Question 5
A Data Analyst is the owner of an alert.
The analyst receives an email notification that the alert was suspended.
Where should the analyst go to resume the suspended alert?
- A. The Notifications area in Tableau Prep
- B. The Data Source page in Tableau Desktop
- C. The Shared with Me page on Tableau Cloud or Server
- D. The My Content are on Tableau Cloud or Server
Answer : D
Question 6
A Data Analyst creates a worksheet named Sales by Region and hides the title of the worksheet. The analyst prints the worksheet as a PDF file and notices that the worksheet title appears. The analyst needs to prevent the title from appearing when printing the worksheet as a PDF.
Which setting should the analyst configure from the File menu in Tableau Desktop?
- A. Page Setup
- B. Share
- C. Export As Version
- D. Export As PowerPoint
Answer : A
Question 7
A Data Analyst has the following visualization.
What should the analyst use from Totals on the Analysis menu?
- A. Column Totals to Top
- B. Show Column Grand Totals
- C. Show Row Grand Totals
- D. Add All Subtotals
Answer : C
Question 8
A Data Analytics plans to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart. The analyst has already built the line chart. The shape chart will use the same measure named Population on the axis.
The analyst needs to configure the shapes to be much larger than the default shape size compared to the line.
What should the analyst do?
- A. Duplicate Population. Drag the duplicate to the second Marks card and configure the size of the marks independently.
- B. Change Population to a discrete dimension and drag it onto Size.
- C. Select Shape on the Marks card for the second axis. From Select Shape Palette, select Custom, and then select Reset.
- D. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository.
Answer : A
Question 9
A Data Analytics has the following dataset that contains null values in the Profits field.
The analyst wants the data to appear as shown in the following table.
Which two formulas achieve this goal? (Choose two.)
- A. IF [Profits] !=null then [Profits] END
- B. ISNULL ([Profits])
- C. IFNULL ([Profits],0)
- D. ZN([Profits])
Answer : CD
Question 10
From Tableau Desktop, Data Analyst signs in to a site within Tableau Server.
What appears in the list of available data sources when the analyst searches for a published data source?
- A. All the data sources to which the analyst has access within the site.
- B. All the data sources published to the site.
- C. All the data sources published to the Tableau Server within the unlocked projects to which the analyst has access.
- D. All the data sources published to the Tableau Server.
Answer : A
Question 11
A Data Analyst looks into the item hierarchy in a dashboard.
Which three elements are floating? (Choose three.)
- A. Show/Hide
- B. Total Sales
- C. Legend
- D. Filters Container
- E. Horizontal Container
Answer : ACD
Question 12
A Data Analyst has the following chart.
The analyst needs the top 10 values to appear in a different color. The top 10 values must be colored dynamically.
What should the analyst do?
- A. Select the top 10 bars, and then change the color by selecting Color on the Marks card.
- B. Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.
- C. Create a group field that groups the top 10 values into one group with the rest of the values in another group and drag the group field to Color on the Marks card.
- D. Select the top 10 bars, create a set, and then drag the set to Color on the Marks card.
Answer : B
Question 13
A Data Analyst plans to add a top N filter.
Which field type should the analyst use to filter by in the top N filter?
- A. A continuous measure
- B. A discrete dimension
- C. A set
- D. A table calculation
Answer : B
Question 14
A Data Analyst has the following dataset.
The analyst needs to analyze the relationship between math scores and history scores as shown in the following exhibit.
Which three actions should the analyst perform? (Choose three.)
- A. Drag in a Trend Line from the Analytics Pane.
- B. Add History Score and Math Score to the Marks card.
- C. Drag Student ID to Detail on the Marks card.
- D. Right-click the y axis, and then select Add Reference Line.
- E. Add Math Score to the Rows shelf and History Score to the Columns shelf.
Answer : ACE
Question 15
A Data Analyst has a dashboard that contains a parameter named Start Date.
The analyst needs to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.
What should the analyst do?
- A. Create a data source based on the Excel worksheet and create a calculated field based on Start Date, From the Data pane, add the calculated field to the data source filter.
- B. Create a custom SQL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.
- C. Create a custom SQL query that references Start Date in the WHERE clause.
- D. Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.
Answer : D